SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


/** Create Tables **/

/* Create stored procedures */
CREATE PROCEDURE dbo.[DnnProduct_CDS_AssetsGet]
	@ID int,
	@DistributorID varchar(50)
AS
BEGIN
	SELECT
		[ID],
		TemplateID,
		ResourceID,
		CategoryID,
		DistributorID,
		Identifier,
		Active,
		Title,
		Format,
		Creator,
		Publisher,
		Link,
		LinkType,
		DRMType,
		PackageStatus,
		Packaged,
		MaxDownloads,
		FileSize,
		ModificationDate,
		Notes,
		SKU,
		ISNULL(ListPrice, 0),
		Archived
	FROM [DnnProduct_CDS_Assets]
	WHERE [ID] = @ID AND DistributorID = @DistributorID
END
GO
